package com.sky.task;

import com.sky.entity.Orders;
import com.sky.mapper.OrderMapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.time.LocalDateTime;
import java.util.List;


@Component
@Slf4j
public class OrderTask {
    @Autowired
    private OrderMapper orderMapper;

    /**
     * 定时取消未支付的订单
     */
    @Scheduled(cron = "  0 * * * * ? ")//每分钟执行一次
    public void processTimeoutOrder(){
        log.info("定时处理超时订单:{}", LocalDateTime.now());
        LocalDateTime time = LocalDateTime.now().plusMinutes(-15);
        //select *from ordes where status=0 and order_time < date_sub(now(),interval 10 minute)
        List<Orders> ordersList = orderMapper.getBystatusAndOrderTimeLT(Orders.PENDING_PAYMENT, time);

        if (ordersList!=null && ordersList.size()>0){

            for (Orders orders : ordersList) {
                //update orders set status=3 where id=?
                orders.setStatus(Orders.CANCELLED);
                orders.setCancelReason("超时未支付");
                orders.setCancelTime(LocalDateTime.now());
                orderMapper.update(orders);
            }
        }
    }

    /**
     * 定时取消已支付但未接单的订单
     */
    @Scheduled(cron = "0 0 1 * * ? ")//每天凌晨1点执行一次
    //@Scheduled(cron = "0 */5 * * * ?")//每5分钟执行一次
    public void processDelivieryOrder() {
        log.info("定时取消已支付但未接单的订单:{}", LocalDateTime.now());
        LocalDateTime time = LocalDateTime.now().plusMinutes(-60);
        //select *from ordes where status=1 and order_time < date_sub(now(),interval 30 minute)
        List<Orders> ordersList = orderMapper.getBystatusAndOrderTimeLT(Orders.DELIVERY_IN_PROGRESS, time);

        if (ordersList != null && ordersList.size() > 0) {

            for (Orders orders : ordersList) {
                //update orders set status=3 where id=?
                orders.setStatus(Orders.COMPLETED);
                orders.setCancelTime(LocalDateTime.now());
                orderMapper.update(orders);
            }
        }
    }}
